Bar: # of Applicants vs YoY 15

# of Applicants vs YoY

Create New Worksheet

Click New Worksheet, Rename it to '# of Applicants vs YoY', Double click title to Edit format. (Size 11, Bold)


Create Bar chart

Drag and Drop Region in Columns and Applicants in Rows, Click descending order icon,  Bring in cc. YoY Applicants and cc. YoY Units Available to the right axis, Change Marks (SUM(Applicants) to Bar, Measure Values to line),  Fit Entire view, Right Click to Edit axis -remove titles.

See gif




Create Drill-through

Drag and Drop the Region & State pill,  Hide field name, Uncheck show header, Go to Worksheet, Select Actions, Dialog box opens - Add filter, Select Change Parameter, Update Empty Parameter, click OK, Click on the Drop down Arrow on the Region & State pill, Select Sort, nested, Descending, Field name is Applicants.

See gif




Color and Format 

Edit Color Double click to edit with given Code (Applicants  #5c6068,  cc. YoY Applicants  #1f77b4,  cc. YoY Units Available  #c16941 ),  Right click on sheet space, select format to edit, Click on the Right axis to format and edit the  values.

See gif




Date Filter and Tooltip

Drop Year of Date to filter shelf, Select Range, 'Add to Context', Select ALL, Drag and Drop cc. YoY Applicants and cc. YoY Units Available to Tooltip, Right click on each to Format to Percentage.  Click tooltip and Add  

<Region>

Applicants: <SUM(Applicants)>

cc.YoY Units Available: <AGG(cc.YoY Units Available)>

cc.YoY Applicants: <AGG(cc.YoY Applicants)>

Click OK


See gif 


Parameter and Drill down: https://www.youtube.com/watch?v=JWS71vSjUj0